How to: Modify a built-in template.
Solution:
Open the template to modify and make the necessary changes in the appropriate sheet of the template.
1) Open the template to modify:
a) Select the 'File' menu and select 'Open...'. (The Open dialog box appears.)
b) Open the Spreadsheet Solutions folder.
1] Select (click once on) the Microsoft Office folder.
2] Click 'Open'.
3] Select (click once on) the Templates folder.
4] Click 'Open'.
5] Select (click once on) the Spreadsheet Solutions folder.
6] Click 'Open'. (The folder opens.)
c) Select the template to be modified.
d) Click 'Open'. (The template is displayed on the screen.)
2) Click 'Customize Your <x>' sheet tab, where <x> is the name of the selected template.
3) Follow the instructions on the sheet to make the necessary changes to the template.
CAUTION: Try to avoid making changes to the other sheets of the template because doing so might prevent the template's formulas and macros from working properly.
NOTE: The changes made will affect only new workbooks created based on the modified template. They will not affect any existing workbooks.
